select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'PA' order by rank asc limit 0,100 Surnames > P > PA > %22

Surnames > P > PA > %22

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
PA PE PF PH PI PJ PL PN PO PP PR PS PT PU PY
PA PAA PAB PAC PAD PAE PAF PAG PAH PAI PAJ PAK PAL PAM PAN PAO PAP PAQ PAR PAS PAT PAU PAV PAW PAX PAY PAZ

Full Surname List Starting with %22(Alphabetical)